2012-08-24 - 2897.900 - Rel Notes - Royalties Report #BIReleases2012

Release Notes

2897.900 - Royalties Report

Admin Info

---

Purpose	Royalties Report
Release No	001
Submitted	08/24/2012
Submitted By	Narendra Koraganji
Source/Destination Systems	IT > BMS > Production to Public Folders / Reports / Commissions and Royalties
Release Sent To	Danny Clare
Object(s) Created By	Kevin Pitkin
Object(s) Tested By	Narendra Koraganji

Transport and Technical Objects

---

Royalties Report - EMEA

Release Notes

---

For Infrastructure

None

For Requestor

This report is going to be designed using SAP BEx queries to fetch current year revenue, Last year revenue, current year open value, Region, Country, Sales Rep and Customer values using the following formulas:
1. Calculating total (current year revenue + current year open).
2. Calculating variance between total and last year revenue.
3. Calculating royalty variance between current year and last year.
4. Calculating coverage percentage on total and Last year revenue.
5. Using currency conversion files.

Reference Document(Specification)

---

2012-02-29 - 2897.900 - Spec - Royalties Report